SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001175s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 554829 LIMIT 1 [ RunTime:0.000308s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 554829 [ RunTime:0.001607s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (344299,843566,820848,846216,600200,50691,548553,422846,380051,507014,560621,457076,406190,424005,979728,380270,1004143,611565,113808,105150,512696,51926,213067,918067,493013,786364,878504,952892,982751,1036669,386417,170791,119291,514868,559464,839459,281868,508947,638833,1028651,124499,608773,149528,585566,544626,1016838,1001722,366728,164551,569514,497421,706747,90660,210268,419265,623873,316523,91959,54873,288040) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001036s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 554829 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000350s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 554829 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000586s ]