SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001166s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 493501 LIMIT 1 [ RunTime:0.000306s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 493501 [ RunTime:0.001689s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (149495,398724,575169,524882,610750,257836,456501,452366,143564,472321,959658,205117,778232,860663,671424,850829,834242,611606,1030404,431565,458015,517244,794130,394722,139525,854604,117357,323786,804042,739325,374212,594838,1036934,934653,227507,430831,440613,295366,925356,432272,637628,298773,554827,695390,95257,748126,804677,954567,956448,186861,845418,84424,109710,291225,77635,463246,722210,395345,965004,820390) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001056s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 493501 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000367s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 493501 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000538s ]