SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001230s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 972522 LIMIT 1 [ RunTime:0.000414s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 972522 [ RunTime:0.001478s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1001928,26199,133442,971622,642687,504437,578017,815454,1009467,426900,312528,357495,110128,722689,177143,853469,697209,1025647,269335,733543,198914,1015110,780055,686326,794468,151809,173221,536262,642181,634066,771741,187503,642698,196213,779974,97954,379524,677757,8417,472552,762592,441225,136630,484899,687344,776867,299949,718466,162530,677174,315757,99493,302850,586804,718951,959544,125950,732524,952573,421772) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001337s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 972522 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000403s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 972522 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000557s ]