SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002521s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 575176 LIMIT 1 [ RunTime:0.000638s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 575176 [ RunTime:0.003252s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (247736,459468,316966,561390,506521,432524,4290,203570,1027140,325184,467418,84114,230486,10497,876059,342604,772518,324326,1030910,685500,1029761,932929,566479,254021,797263,871804,79120,968432,748712,410931,509533,496790,70769,39708,60075,500850,73958,282411,970090,1042621,1036845,857890,575887,1031986,984202,802138,1002518,1001784,922932,550294,880296,802053,202142,866251,863769,581275,81860,933273,837847,760797) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.007058s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 575176 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000443s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 575176 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001101s ]