SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001175s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 409717 LIMIT 1 [ RunTime:0.000383s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 409717 [ RunTime:0.001726s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (303337,642160,387803,444058,722690,170233,759497,24665,348471,605370,252736,675225,661532,711371,368976,236359,505838,916853,812087,490057,596760,286523,452012,1034656,248412,713485,787552,284382,786431,1015514,1003767,219899,100333,827948,530300,697535,242640,851028,237807,23310,294495,924450,497912,879003,881221,620504,74760,650248,100051,225690,597158,552841,621831,698704,130781,37839,142819,420219,717823,520242) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000997s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 409717 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000338s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 409717 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000462s ]