SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001256s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 663053 LIMIT 1 [ RunTime:0.002274s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 663053 [ RunTime:0.001671s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (521904,1042006,298803,905697,508753,546688,44810,816242,214755,201398,403941,629293,497144,694988,321158,175763,117438,25652,81333,356981,504862,153935,681723,717898,393689,7222,592368,555426,398967,61655,363022,542752,10861,15810,564211,1041000,997794,377432,732557,726456,80403,364418,605182,588149,789355,741276,16802,521738,388226,113480,149402,378383,26384,305862,612511,695714,337877,662803,931094,372951) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001108s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 663053 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000375s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 663053 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000553s ]