SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001296s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 502845 LIMIT 1 [ RunTime:0.000427s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 502845 [ RunTime:0.001545s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (3073,162372,799627,506597,910358,353710,476637,241503,931239,181928,631816,1032729,119357,929938,582763,225574,827272,115454,659633,907619,504638,414500,619288,50793,894427,744023,40760,890054,219825,409854,333669,710886,11944,414016,352795,705550,794612,943342,366,621087,32424,675347,798806,143863,165342,921502,466310,127273,59823,466960,346695,610149,345119,889989,427117,77787,657735,849893,745315,399509) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002027s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 502845 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000383s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 502845 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001161s ]