SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001087s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 528508 LIMIT 1 [ RunTime:0.000312s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 528508 [ RunTime:0.001598s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (598694,354320,123635,85256,1036677,287959,629174,387941,823527,492358,516214,854630,139239,991845,12417,861717,589049,943885,797753,24398,382847,871085,867088,1013337,543477,977601,444156,805825,735899,33566,650229,56053,334314,322566,492917,23551,212968,800910,727028,371207,120893,296028,545044,530990,788291,544830,363276,244097,679612,761982,714633,731095,585931,708854,1001261,21406,711514,804673,461882,430614) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001025s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 528508 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000342s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 528508 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000413s ]