SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001410s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 547218 LIMIT 1 [ RunTime:0.000388s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 547218 [ RunTime:0.001541s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (267063,440010,915524,104866,721237,1003591,458795,586586,86341,807175,486598,311242,766290,808177,776006,402057,19177,181897,1024093,20915,718658,309805,385422,645044,84399,166802,674329,856413,798245,549708,960171,604960,16306,124211,943338,256219,382403,147966,1018064,202577,608910,375436,667972,524371,264213,972028,771836,475808,941741,758295,879190,910353,42377,704801,315985,237386,887557,906301,528322,87386) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001098s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 547218 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000409s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 547218 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000584s ]