SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001608s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 474704 LIMIT 1 [ RunTime:0.000555s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 474704 [ RunTime:0.001854s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (339519,60188,339807,337109,518835,343286,876632,365936,875848,848391,716543,989489,434026,617080,410289,489751,815778,93977,59748,512346,841204,920847,892936,306086,982646,138606,873280,954572,151921,133397,63403,1004603,552760,572863,992389,656156,568535,248884,969488,841922,874873,626144,348944,542542,141369,796418,966671,840059,188934,138818,515716,577663,394637,537572,874422,803128,103632,263585,123699,378872) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003360s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 474704 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000496s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 474704 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000582s ]