SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001486s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 107912 LIMIT 1 [ RunTime:0.000446s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 107912 [ RunTime:0.001780s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (947221,820398,635733,871579,509861,321644,342095,432958,822017,301350,487729,152974,183587,208003,730105,189703,995385,743054,589683,373658,926160,838198,947742,39834,144627,397325,804524,7924,831035,432631,16441,846897,607543,1031286,385440,338768,234133,989741,1008429,581013,217917,221562,289379,35740,885320,16447,606750,733045,514167,571094,339314,913867,356028,201828,461780,903677,326642,964889,821824,942941) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002307s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 107912 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000483s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 107912 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000506s ]