SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001823s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1034001 LIMIT 1 [ RunTime:0.000395s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1034001 [ RunTime:0.001862s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (866036,923878,827425,19393,348978,468429,180291,614882,675212,712406,883356,738854,285359,866037,774202,991663,967554,161261,167701,179117,959457,582224,522652,556531,614865,943407,11128,320851,721949,833748,923792,404030,870074,349890,772177,452776,556822,301401,256722,1025544,97359,88038,867149,612386,121111,209501,632292,27460,848567,816614,304611,802545,255284,433733,179277,163348,417486,334079,1042519,595899) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001178s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1034001 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000447s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1034001 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000595s ]