SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001131s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 803798 LIMIT 1 [ RunTime:0.000311s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 803798 [ RunTime:0.001878s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (385504,112673,612232,1039271,382103,440485,980941,15367,442513,269197,392639,170324,397744,960573,434455,889173,699761,659493,688149,733970,33709,608797,624093,627081,788939,276401,472845,262756,920514,402263,143230,246140,60707,513013,943215,521610,596364,848378,160087,853994,76697,825213,664098,532005,25108,677131,41779,529540,433360,121519,1017195,842210,1047368,492923,976515,17046,396553,77248,264475,390173) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001049s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 803798 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000666s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 803798 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000515s ]