SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001431s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 241343 LIMIT 1 [ RunTime:0.000415s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 241343 [ RunTime:0.002897s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (580464,986358,939964,756615,1038303,1032568,994000,612002,381263,707164,594826,539537,383381,443405,113495,906581,1002151,509497,96902,593921,830984,143857,839216,306912,864857,761862,42724,218099,85826,944985,22027,256072,201152,107043,288592,1041850,653167,938604,339190,931528,747581,1035453,82643,53900,337261,854825,670539,475649,968450,786040,957944,597760,86225,983677,386602,1019142,881327,949669,812536,291553) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001228s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 241343 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001516s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 241343 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000815s ]