SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001164s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1029465 LIMIT 1 [ RunTime:0.000510s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1029465 [ RunTime:0.002741s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (212028,1034294,920460,424720,642519,956835,685546,799189,18526,379954,641683,722760,898268,371661,942938,688740,882089,526246,534153,1006866,919181,481726,897556,254133,260397,241327,328656,1048054,460035,79532,758613,614218,375011,304490,74775,351518,283646,55557,264073,223983,629089,683186,799659,235955,454169,986514,430414,643053,640265,448578,879505,1035319,640551,849939,1012403,487951,6182,282207,468812,479046) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001181s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1029465 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000361s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1029465 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000507s ]