SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001111s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 199884 LIMIT 1 [ RunTime:0.001521s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 199884 [ RunTime:0.001904s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (464831,41248,951149,992772,774214,294354,705843,436552,123083,489388,428169,988995,424932,395902,286420,102947,296435,67440,907760,685075,44485,632472,690731,541563,196027,353777,635172,32551,547871,596292,361378,407682,675654,188793,675849,443714,1044675,227781,596631,988110,588076,354609,384016,932313,183670,166697,374200,854408,255638,527972,732972,897214,703450,689798,700315,125433,265227,186311,1034557,943155) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002427s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 199884 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000488s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 199884 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000443s ]