SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001078s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1039789 LIMIT 1 [ RunTime:0.000521s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1039789 [ RunTime:0.002342s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (503091,713638,954288,934003,6606,761614,981735,816231,838301,286623,592105,551492,968959,460864,870999,598622,114021,546872,484258,850231,12780,330646,856831,764244,545264,245132,630759,93871,1003132,683764,823430,594509,489895,965622,134930,453197,302768,130109,154400,663193,371455,601033,936009,290315,714699,695511,581478,694856,661775,940522,53446,477229,210098,25883,1039841,212620,300190,587959,942961,65375) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001054s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1039789 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000383s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1039789 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000605s ]