SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001643s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1026175 LIMIT 1 [ RunTime:0.000431s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1026175 [ RunTime:0.001809s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (431480,612534,550703,366811,458636,324707,397836,586533,457562,951380,1005498,715957,703981,879475,93322,48771,561141,102732,950124,822735,359263,464107,469519,802000,1004987,975960,85623,630824,10174,408302,684655,310445,404786,985007,540476,924051,79077,988590,656170,797799,124144,915673,18474,914447,780168,815253,484321,374741,908551,273112,990077,205732,626582,446509,1038435,743651,335102,153203,44404,174208) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.006673s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1026175 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000492s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1026175 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002664s ]