SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003303s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 512844 LIMIT 1 [ RunTime:0.000390s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 512844 [ RunTime:0.001766s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (510397,85892,457674,443919,407459,624640,68763,19420,192897,184551,362835,54853,905353,125006,907792,608314,748883,64209,524302,708077,215892,988866,326309,59913,695487,595703,546470,333403,423123,470629,64739,393246,321612,642345,989616,755311,746136,608579,940141,717112,216353,949165,604735,400879,55951,708529,747199,3634,1008761,662589,119578,200599,728931,578844,54842,821855,790316,430650,447198,537713) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001016s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 512844 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000380s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 512844 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000615s ]