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` = 502781 LIMIT 1 [ RunTime:0.000346s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 502781 [ RunTime:0.001718s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (545569,90619,69188,430298,669299,1029141,343937,591462,684242,111600,265099,674230,344656,133533,396066,868228,436106,819166,473106,1020340,364579,102579,953442,724868,286845,792661,1010606,350660,989324,697988,1045654,963143,373306,474489,345564,433932,795520,740323,763286,63872,876171,1017933,592018,454060,407898,1021082,638985,463241,586512,145969,782664,94305,874610,798058,947365,1043598,898400,980784,833786,559668) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001086s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 502781 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000381s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 502781 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000536s ]