SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002688s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 103978 LIMIT 1 [ RunTime:0.004237s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 103978 [ RunTime:0.008765s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (864481,235610,757217,402596,532690,478076,555742,484184,646853,548813,658897,39765,717313,779779,526947,472647,304125,945853,637456,971386,812930,1044292,786032,444964,1016938,175653,981842,168517,265215,241586,319787,1047916,552189,903676,435894,389726,197798,495943,550694,315558,779328,640261,602102,494669,429674,951377,699611,375629,611880,758841,550258,448794,104819,361425,456383,302467,920933,419784,872667,662446) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002339s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 103978 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000379s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 103978 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000665s ]