SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001856s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 100040 LIMIT 1 [ RunTime:0.001558s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 100040 [ RunTime:0.002147s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (920326,661845,498908,437404,633884,703702,705511,894441,866782,678008,80714,630384,666803,900347,283339,606847,948499,220954,5661,623427,108161,462348,358881,916404,1033365,442200,320862,196981,1002405,811670,851434,736935,811145,610538,628791,60840,766931,639604,750500,509326,995247,463087,1026605,926017,605798,24270,892598,689059,592890,569254,932826,440171,683626,254880,25512,412421,788629,67347,154208,713865) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.006445s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 100040 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003920s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 100040 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000755s ]