SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001190s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 401371 LIMIT 1 [ RunTime:0.000374s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 401371 [ RunTime:0.002461s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (823942,104335,486755,231221,1033275,94551,814411,489393,826480,340142,759247,301457,905694,576673,943237,390669,585106,912319,67847,1004729,852184,185712,320891,374866,448126,907850,226987,499467,409458,1004159,432783,880401,176018,278566,537255,222105,569959,527501,955290,954428,647529,360054,744893,652858,563241,964687,909515,197105,567111,489638,166211,323531,34793,462845,772221,793002,77329,271633,782977,307924) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001827s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 401371 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001244s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 401371 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000588s ]