SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001137s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 499910 LIMIT 1 [ RunTime:0.000333s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 499910 [ RunTime:0.001416s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (429437,43097,444199,591896,877153,50740,997705,78768,432684,719903,402276,195042,539816,206387,750027,246444,597454,165062,372571,288411,645669,639921,920736,251385,578577,446190,641319,623285,555488,652229,940952,626845,862720,296454,924559,28426,9393,911394,464838,625010,97299,302670,827154,155275,427986,965703,993001,519056,814802,200842,635129,300455,59287,68002,540341,581597,420180,303685,960968,787369) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001005s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 499910 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000333s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 499910 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000487s ]