SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001412s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 415328 LIMIT 1 [ RunTime:0.000376s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 415328 [ RunTime:0.004011s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (384282,435507,278015,799358,989097,301400,820497,846396,67243,960141,131402,316489,486121,717401,468347,715684,878478,454337,726119,162048,303063,313230,420253,606016,364624,208255,686427,872601,303666,671426,557966,223532,260383,152874,262467,46166,479459,213507,49770,888119,1034424,733856,299019,437830,998857,447791,678326,588080,329058,391686,694552,720645,744866,355537,612577,489602,272492,618459,823488,1012347) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001356s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 415328 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001186s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 415328 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000608s ]