SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002144s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 511682 LIMIT 1 [ RunTime:0.000315s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 511682 [ RunTime:0.001791s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (478808,459300,273335,950286,452926,240341,413443,436402,734742,177371,335851,516125,489493,1022887,673871,881176,291901,707726,611725,313678,128315,32880,329658,767121,180404,815844,670062,225717,279315,728118,1014558,963847,919926,784577,1040130,267999,74394,704321,179897,554787,453068,680375,399114,109682,595345,460621,356383,441968,403647,1003533,724696,345049,377121,253284,524258,19913,992412,455246,851563,464207) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001253s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 511682 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000749s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 511682 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000599s ]