SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001679s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 513906 LIMIT 1 [ RunTime:0.000397s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 513906 [ RunTime:0.002707s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (741903,249212,896030,597335,484500,523095,301424,411178,921080,384966,658946,921356,320194,367475,558643,963856,559323,908330,622205,264825,418577,665214,582036,272268,870957,953949,324269,55300,766016,705429,1008179,746058,202933,1013662,979263,39228,970837,943276,263599,395676,621632,665810,852893,152645,239599,400774,937666,717704,470965,389624,283467,185218,1038011,530401,419730,580308,540693,917100,365451,175506) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001267s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 513906 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000978s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 513906 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001816s ]