SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001169s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 531206 LIMIT 1 [ RunTime:0.000360s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 531206 [ RunTime:0.002004s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (804638,567474,704332,363160,120438,833994,295329,431248,83941,394741,576498,514412,39398,390661,570016,351542,574256,912394,761109,91164,886793,667210,554657,266331,203759,500265,378354,471601,151829,611057,1001369,245205,842152,957530,49578,1046697,714790,259577,157818,356427,455396,114334,756304,654326,374802,472416,120098,298785,735772,223343,897244,195381,470774,368062,1007467,164345,560379,406713,828592,904940) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001179s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 531206 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000417s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 531206 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000325s ]