SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001160s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 443530 LIMIT 1 [ RunTime:0.000357s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 443530 [ RunTime:0.003848s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (829456,706605,115895,395044,1042667,173454,259042,893665,927234,971631,946617,99881,901003,799573,860226,348000,761937,747954,14492,535279,684790,1023631,23796,966438,462059,504026,585831,261329,104825,496135,630880,344908,344631,805081,581292,402325,575745,360157,988391,677299,294058,1008556,551245,668671,302228,347132,696721,602742,334568,75754,427233,456518,937191,197558,483906,457226,787214,340812,178984,520131) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001135s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 443530 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000378s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 443530 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000457s ]