SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001356s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1020878 LIMIT 1 [ RunTime:0.000444s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1020878 [ RunTime:0.001782s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (707975,848556,380960,700366,661384,1005612,875780,292890,852194,901856,639040,994351,800235,426302,243688,521089,660384,377883,348853,433484,919444,855203,417686,1009442,643938,125392,123933,512131,136210,594859,140072,880032,999632,560913,665651,991352,645400,389727,399484,372338,157724,979447,194157,87397,603890,127579,617189,637142,504509,933628,140705,1010716,541659,306715,392531,392170,1008426,8138,193219,427656) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001296s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1020878 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000406s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1020878 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000701s ]