SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001427s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 408798 LIMIT 1 [ RunTime:0.001461s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 408798 [ RunTime:0.002925s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (208122,1021031,302749,863648,534051,386452,645431,673456,210654,391676,210950,1039496,1012530,864893,704404,802445,454928,889166,996027,649692,799755,4470,447243,535004,595738,240706,516311,941669,609626,583206,351398,690477,219588,919673,127536,824467,116626,98547,567884,208016,205960,145225,563686,882568,1024534,942098,3401,741992,713411,626974,224313,439925,380284,76647,346296,820855,727358,825141,705334,1039040) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002417s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 408798 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000537s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 408798 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002868s ]