SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001175s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 960791 LIMIT 1 [ RunTime:0.000410s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 960791 [ RunTime:0.002623s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1034606,730771,185950,285026,19838,266349,305611,514069,984400,104541,850075,146014,87929,775156,340025,261938,782971,124835,291804,477540,577217,184366,500225,118347,51765,972920,829168,1027828,397944,722160,739830,799782,1004272,912034,1019696,309037,792931,891414,195891,45445,224456,173299,205984,523497,618326,1031197,480545,222613,849920,850255,858157,826335,299278,144354,239127,325315,874412,59327,957167,47090) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001100s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 960791 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000718s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 960791 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000435s ]