SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001108s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 514806 LIMIT 1 [ RunTime:0.000302s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 514806 [ RunTime:0.001742s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (458977,226928,672807,354965,135360,667324,757735,495012,1044218,702734,1017777,251329,764716,174632,277362,397001,173345,493287,928621,243892,30900,673035,23136,501627,878267,902522,913760,445894,620505,757638,152657,552333,24260,159379,917966,353976,448402,849140,891919,765150,595177,481342,664452,210156,863060,563037,696387,447692,88864,217730,668279,527015,497670,726644,544325,431190,748855,690262,816603,144601) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000982s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 514806 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000425s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 514806 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000569s ]