SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001379s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1001809 LIMIT 1 [ RunTime:0.000310s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1001809 [ RunTime:0.001981s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (317575,806632,72963,534515,351549,299541,110287,78797,779995,71875,371479,483160,699961,227284,975340,497370,671844,568505,772616,963161,855194,111216,580037,2288,707994,756125,242861,425799,487875,853648,847201,81625,472452,825960,194856,454086,709159,244439,645758,820164,419600,60622,37213,375103,168830,413861,791857,374128,356181,199609,806877,377734,531255,596809,598183,1029036,590750,97430,125050,259389) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001236s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1001809 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000392s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1001809 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000476s ]