SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002386s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 801509 LIMIT 1 [ RunTime:0.000448s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 801509 [ RunTime:0.002465s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (22121,827454,227479,606280,260914,454157,785099,883710,975914,221295,558216,759122,499680,220111,337497,984181,968915,1040625,597139,482316,241539,184413,412318,663866,238982,444580,775661,428615,162733,836382,647776,335888,934299,765027,564180,35429,17717,52917,94496,590913,144427,901836,878488,312273,509076,350943,482726,681780,566896,679828,946298,550093,173771,818607,295286,733085,938799,423987,969320,534084) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001693s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 801509 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000361s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 801509 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000475s ]