SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001154s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 403043 LIMIT 1 [ RunTime:0.000322s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 403043 [ RunTime:0.002303s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (288388,662895,655616,569394,148641,417172,409818,1038835,470361,912436,259509,822901,809745,35371,500890,658450,425035,610453,798867,322937,484971,85915,187392,481148,1025326,378468,140531,927046,346991,298172,430266,182331,75439,690954,178263,221668,791166,200466,703930,446050,940796,731954,69964,279053,760594,65412,426899,307338,817677,999976,623612,581391,913535,1005279,376380,1039369,296387,897541,11685,302519) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001106s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 403043 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000400s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 403043 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000463s ]