SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001167s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 509116 LIMIT 1 [ RunTime:0.000300s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 509116 [ RunTime:0.001469s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (710364,628368,301507,463144,11612,127325,884644,817036,742527,659871,824506,269427,713860,168983,13824,316284,1027907,669215,495569,126846,109949,941851,547192,305975,434224,357279,461230,896856,462488,820795,747393,451622,130288,447223,986442,603619,546902,466996,425962,397111,371997,513460,701094,1024545,452342,508244,369683,1010882,353259,698986,540762,991686,920424,690444,855413,321338,179782,443042,185464,564936) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001004s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 509116 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000390s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 509116 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001002s ]