SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003492s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 501211 LIMIT 1 [ RunTime:0.001141s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 501211 [ RunTime:0.007479s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (559821,898090,495621,984927,481366,826708,244192,75751,791349,965854,676305,450560,894013,260202,641609,977378,1027025,542439,29469,643152,740469,323906,992284,798896,366215,661112,36392,1007194,500206,802882,856524,988607,941836,104146,845147,668074,781043,124092,445182,238460,284253,174802,368425,562383,448640,563322,500649,383287,709949,400229,1044545,1019298,182041,740497,778132,884987,12345,538643,262592,106632) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001410s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 501211 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000447s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 501211 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001425s ]