SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001214s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 490213 LIMIT 1 [ RunTime:0.000286s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 490213 [ RunTime:0.001836s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (439905,787400,632458,688897,1009281,134333,616385,306530,186297,720538,1021238,12490,1013729,404709,816389,751366,223907,994142,280504,927162,56928,132315,288556,689155,51930,31919,94242,1026560,976888,975844,682776,318875,93833,1029155,384133,375605,626940,967164,497882,10356,488732,772216,841045,1091,476314,132953,942020,605120,850171,654047,1004057,859357,945356,19820,649416,129754,745222,527424,1006308,424447) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002088s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 490213 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000401s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 490213 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000581s ]