SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003807s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 381196 LIMIT 1 [ RunTime:0.002583s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 381196 [ RunTime:0.004658s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1018734,886450,652673,985719,60789,998878,885822,126465,606687,677648,353503,776098,792623,663951,335754,39744,911670,528796,201292,592277,20849,797745,99206,42403,449246,521606,262764,330056,456642,823031,450179,567956,1034045,63943,294464,1036906,712211,17616,514034,294047,1002399,308284,650188,167065,377879,331195,902875,356830,505470,765507,381094,995931,323541,597703,702957,1023647,352991,399790,800672,241480) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002595s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 381196 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000460s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 381196 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000574s ]