SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001173s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1046017 LIMIT 1 [ RunTime:0.000368s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1046017 [ RunTime:0.002155s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (451948,260845,325346,438934,928006,379140,309188,1043968,1027029,832706,929697,1012238,761083,758353,826045,465200,603344,448951,527050,184119,815354,666250,991376,304783,559448,661626,69328,1003262,802094,366311,666588,597526,441949,85266,720640,957502,974698,840764,322888,804902,415139,529089,568895,686675,858302,233131,114602,950570,675305,922924,900992,613582,918744,536217,217718,528797,451389,722649,778989,277167) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001246s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1046017 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000382s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1046017 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002333s ]