SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001295s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 29415 LIMIT 1 [ RunTime:0.000388s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 29415 [ RunTime:0.002364s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (86071,953663,434168,824534,1048541,110133,589645,661900,66754,737958,484472,373366,587760,753776,1018290,463655,202910,36688,132007,995608,971242,347376,149751,28275,345553,919495,648877,392236,1017952,475430,6004,160483,89752,887060,695814,555474,207934,195368,591792,219312,321174,37471,859434,624712,544862,567403,376252,1036319,204,946667,1027007,184563,720218,666764,839075,863516,680609,378528,933784,15084) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001290s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 29415 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001733s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 29415 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000747s ]