SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001148s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 971628 LIMIT 1 [ RunTime:0.000318s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 971628 [ RunTime:0.006255s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (429489,656554,427066,395006,973013,892019,395614,297531,737145,516684,164870,61395,963039,888861,988300,297259,188877,935756,881097,601675,1005349,46983,488455,679088,316863,571685,77224,25820,447916,464443,685783,621605,182926,1007703,598146,631818,593779,855522,911982,770760,513316,953235,448391,381822,1007705,383748,524360,809275,11111,684256,968372,381885,979631,586009,737294,614550,851191,302147,289129,444585) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001234s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 971628 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000392s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 971628 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000433s ]