SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001164s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 381040 LIMIT 1 [ RunTime:0.000315s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 381040 [ RunTime:0.002880s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (393067,470316,15131,598663,586773,211674,395307,105372,354553,895581,866422,760009,685489,1038044,715273,857562,462679,673806,903153,423707,864666,473521,131151,763162,1008810,267029,850241,278536,952718,418676,87398,1030727,351102,544487,130578,94748,466752,505018,883086,569376,919236,38410,948564,93282,26369,197743,47173,118207,366126,1013509,317843,166917,876885,559031,245018,755613,799356,461512,909849,898225) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001120s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 381040 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000359s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 381040 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001573s ]