SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001169s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 107512 LIMIT 1 [ RunTime:0.000389s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 107512 [ RunTime:0.002499s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (814497,58245,648529,678576,82543,444749,117932,867589,137127,110469,769732,347607,503034,939707,445330,378487,31587,376932,562200,975557,59848,581013,890153,636443,381490,510636,658143,430800,146584,879305,1033903,604393,115478,796033,519219,427376,108045,846593,41324,866551,237634,1015358,83888,1031066,174683,934766,663016,530079,375666,1044308,992770,414003,721374,190211,4431,964180,844769,402314,968007,587035) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001450s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 107512 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000443s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 107512 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003182s ]