SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001163s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 489100 LIMIT 1 [ RunTime:0.000320s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 489100 [ RunTime:0.002034s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (384108,926404,992876,976867,253950,168352,193620,559949,527229,544400,136795,343585,812418,673276,1008528,645204,962028,979773,198012,167717,517644,109526,954670,612682,173741,761492,725243,504320,292345,668301,955778,666787,931204,274680,801894,1019480,496935,77040,957616,698165,834763,474315,403909,982038,484638,746605,799623,935800,399869,480986,101236,747835,189442,836608,599161,640657,305969,80780,509806,100653) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001062s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 489100 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000403s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 489100 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000654s ]