SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001220s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1037389 LIMIT 1 [ RunTime:0.000341s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1037389 [ RunTime:0.004423s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (410838,216380,673808,850412,294481,87620,1019656,325014,911833,132029,40909,1034926,777408,480422,317312,842552,1025494,269586,678057,23413,705334,116686,901456,1044611,552674,73102,216220,89614,79110,855275,697115,173240,776884,439106,201244,899335,998260,272940,922942,828450,52878,649925,320584,666660,220514,989274,622470,978337,720987,708950,743912,819079,688984,386198,556890,99181,335977,644562,55652,256722) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001144s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1037389 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000525s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1037389 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000556s ]