SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001486s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 106091 LIMIT 1 [ RunTime:0.000459s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 106091 [ RunTime:0.002907s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (631249,322394,282966,988188,383660,649706,43549,271180,841563,873763,965977,313446,136018,600974,428831,967488,342535,955993,651673,645848,420715,2868,679052,19797,700319,71160,331416,354465,358673,136886,210411,606348,296122,12690,998752,80378,972963,250553,484057,239468,614961,554076,30683,904446,570580,1047533,414381,373725,428051,136942,969592,576672,233904,614777,312252,241677,906814,274835,950443,958671) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001054s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 106091 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000433s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 106091 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000584s ]