SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001065s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 410931 LIMIT 1 [ RunTime:0.000554s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 410931 [ RunTime:0.004781s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (848534,831841,287565,1026018,677840,852613,753983,439357,719141,97489,413523,981107,25388,56568,476459,546369,656374,228184,828912,697694,677291,387744,926971,905447,660346,24365,874194,856776,518561,612388,16510,569423,579621,992844,923214,110178,883090,547132,311810,626797,723801,295272,332471,127270,691151,294706,425178,735803,1010350,92592,670047,227404,195614,754776,412892,605750,247683,421417,790959,203539) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001187s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 410931 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003901s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 410931 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000437s ]