SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001854s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 331812 LIMIT 1 [ RunTime:0.000336s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 331812 [ RunTime:0.001796s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1037380,500279,532183,711154,63136,67060,554748,316109,153373,141040,610182,785330,92877,880244,435036,702918,1041307,794347,541123,76292,76626,829411,411298,903411,415928,308787,467786,1273,365379,198069,660066,380435,53675,162592,670711,129491,848381,325467,871804,700531,9003,1042198,177213,866399,998361,52390,405135,46951,933403,1035370,549954,722563,330766,623266,434327,846164,4939,500758,32656,332627) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001032s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 331812 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000328s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 331812 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000646s ]