SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001205s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 534890 LIMIT 1 [ RunTime:0.000378s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 534890 [ RunTime:0.001570s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (315998,264598,758588,924445,396207,951904,83173,140455,271876,194339,760003,38201,676578,766038,518977,504553,604194,238331,778845,867312,494956,606939,933014,816499,674663,227607,974924,991232,34652,707712,340058,260166,78122,683525,1007194,393515,106747,925293,570134,773621,568872,830229,339755,12256,883441,459943,308436,741064,385899,748537,942135,1032321,902999,783225,199569,357550,821220,730880,96239,236804) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001275s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 534890 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000555s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 534890 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000553s ]