SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001321s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 689401 LIMIT 1 [ RunTime:0.000331s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 689401 [ RunTime:0.002078s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (931153,654515,363134,598001,125353,807635,931005,529437,582611,910331,435752,1041840,871603,440157,988536,166261,552573,1634,377778,402077,824664,499802,743552,238368,51619,25777,876387,11505,653722,736753,815788,774659,10891,452141,83427,488676,7650,297078,249218,109128,673093,822938,829633,465061,217220,667375,1033939,394722,432308,988707,384829,62634,779538,1013082,915991,369796,775448,98612,52832,1023831) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001256s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 689401 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000487s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 689401 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001572s ]