SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001392s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 503612 LIMIT 1 [ RunTime:0.000380s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 503612 [ RunTime:0.001843s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (260137,255501,18979,653915,181640,699149,407941,254854,362984,23560,687041,777534,162999,259864,514301,130624,932153,789234,1007203,573096,674479,378922,855535,899869,229096,620508,824934,797415,314732,232277,805248,466737,559167,375860,958592,31943,916857,75691,988180,642977,55701,414149,124942,329092,296169,435963,389449,924310,223567,759314,595958,958752,41559,327413,2822,532026,657580,49467,459712,22022) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001219s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 503612 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000477s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 503612 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003139s ]