SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002433s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 580161 LIMIT 1 [ RunTime:0.000385s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 580161 [ RunTime:0.001747s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (810059,786430,531311,312100,105689,497700,939141,699031,146349,69642,829729,517932,148056,80162,315332,29688,1006864,771462,567009,102596,865550,343758,577473,690539,302277,286575,381750,246514,453747,219246,751086,80704,421538,250644,320208,262775,293777,58112,620489,747377,8547,705057,996912,748443,495657,152915,852858,178148,439959,16783,949912,738045,537986,487890,659435,567246,1021625,359925,920655,215831) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002074s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 580161 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000362s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 580161 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001272s ]