SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001326s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 434730 LIMIT 1 [ RunTime:0.001382s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 434730 [ RunTime:0.007222s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (276545,795332,9079,262747,526031,387355,291442,239786,280557,117385,196435,904274,274928,842684,486907,99620,969575,244272,826600,21038,375106,2322,592529,113487,47805,389016,935005,458634,416853,570884,558514,838222,162222,410580,743049,652873,243822,2097,455563,534656,650796,16538,627281,346024,113391,868774,93045,231799,521669,389879,508743,811902,687165,464304,343081,345546,135152,399909,805040,578246) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003022s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 434730 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001320s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 434730 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000577s ]