SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003447s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1010154 LIMIT 1 [ RunTime:0.002446s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1010154 [ RunTime:0.001916s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (785637,194132,25183,932538,115742,64526,398225,488622,362655,284160,8674,576710,975873,150078,557596,248783,351714,161001,657506,39332,988602,601118,469753,719325,542983,715710,309457,1018016,584763,433884,12370,413250,1030838,245764,934692,1004426,381855,617188,149211,425592,854197,385213,68848,65687,308745,648190,653328,764755,14004,626422,472140,916581,595337,520104,895850,829676,705211,1037371,873128,572983) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001343s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1010154 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000410s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1010154 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000673s ]