SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001428s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 40927 LIMIT 1 [ RunTime:0.000433s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 40927 [ RunTime:0.001778s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (734830,916620,765513,287526,136037,460868,438197,558227,193084,734471,157100,638178,706189,696623,145636,378763,899754,582011,930688,12122,174790,470299,854711,942556,126821,907020,893271,654354,199807,815938,981616,122782,331219,523814,758717,433676,46226,269648,424497,45955,335640,478368,330027,839131,977373,698148,34451,678629,970419,119820,303112,922164,948757,1010013,881337,20126,185677,499437,278233,454603) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001334s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 40927 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000407s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 40927 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000716s ]