SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001237s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1014543 LIMIT 1 [ RunTime:0.000421s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1014543 [ RunTime:0.001768s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (907876,306590,273742,547488,894014,526991,913542,516929,35591,625498,499202,285595,990645,30568,795734,791596,559766,542141,756598,287903,417486,213114,193943,323974,758460,51487,240308,551886,637075,67445,82838,1020717,223595,738369,232728,70207,375545,641221,377150,859990,769915,666674,58553,972075,354118,463454,227567,259781,32171,599628,911692,218629,134387,628337,220290,952430,520675,57372,918840,898671) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001388s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1014543 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000548s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1014543 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000567s ]