SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.005060s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 569039 LIMIT 1 [ RunTime:0.003317s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 569039 [ RunTime:0.001956s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (149918,453015,981099,558164,934139,268209,566462,938429,301752,308405,648258,524944,68097,199846,528523,909895,483436,393442,513395,234676,550387,843683,307199,334601,931343,926432,629317,799664,198949,589435,499186,102552,1031493,22170,204822,982976,997804,188015,413058,248949,673871,651166,487210,872917,287635,704852,426242,489093,705195,1028105,185659,552768,906754,191524,25526,638182,124713,384404,1110,987890) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001289s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 569039 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000432s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 569039 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001852s ]