SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001218s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 598628 LIMIT 1 [ RunTime:0.000364s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 598628 [ RunTime:0.002015s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (510480,182061,1023907,24304,775258,924126,68234,662986,838241,267037,1016560,764190,754968,360499,115343,137181,513042,745542,574580,715931,244658,177458,646074,41057,156739,221069,370287,121590,847725,264695,451831,657254,4058,747282,540369,700784,43747,783350,148495,31294,460820,887398,9922,799278,141494,844892,55856,873615,228651,392523,679520,564645,437529,297060,817420,378272,385647,511637,913484,733753) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001308s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 598628 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000373s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 598628 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000535s ]