SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001118s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 401500 LIMIT 1 [ RunTime:0.000344s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 401500 [ RunTime:0.001584s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (252198,780382,151457,1014623,279119,251244,99303,638996,546508,428893,446778,53927,554408,522979,383452,401322,464601,825623,536204,566597,351018,229502,120111,500995,543297,986609,994434,511541,188750,1045870,922956,545047,217362,148730,660509,906849,607803,779600,496177,536500,367229,915811,356375,913711,95357,1044215,341130,285032,305805,436170,262899,219177,410492,593251,332294,96076,130542,966225,341420,331325) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001018s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 401500 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000355s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 401500 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000538s ]