SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001212s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 662896 LIMIT 1 [ RunTime:0.000373s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 662896 [ RunTime:0.002094s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (103410,311953,564950,305157,796902,729762,919444,9167,583434,1002703,418579,1001218,351041,875120,631882,158832,335301,125967,91342,523690,190786,362656,198270,529416,480426,440440,370836,37474,719167,1016024,547815,615223,681552,720651,681799,46995,576244,129679,269982,248327,915770,986118,276472,1022435,1017308,178089,432150,559193,541536,444975,638180,98780,542249,752697,14241,989241,733546,445236,983646,886618) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001293s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 662896 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000479s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 662896 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000626s ]