SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001248s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 405442 LIMIT 1 [ RunTime:0.000352s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 405442 [ RunTime:0.001664s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (263190,306345,768192,836429,90274,664480,958724,381588,286992,133843,467552,778170,929087,834319,985457,9722,575549,539668,465357,584306,845346,572859,141619,851734,836095,1020563,879891,945841,247044,557879,281641,754378,430731,262533,256507,417911,1006625,791754,952353,545870,966160,811435,460953,19861,509897,504482,441032,407445,164568,832077,792631,521958,68919,1014636,11028,178894,11781,921273,799832,236895) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001105s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 405442 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000471s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 405442 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000586s ]