SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001272s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 475323 LIMIT 1 [ RunTime:0.000361s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 475323 [ RunTime:0.001735s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (504908,169867,789632,779929,188365,662355,286274,439546,973099,720485,576503,451079,91393,920111,964386,454036,469373,753241,906717,395582,617781,1008459,919551,715120,670366,523600,575171,795060,1036945,362762,462995,380804,162171,57569,53235,180194,442362,23050,801785,175600,713572,283202,538244,1038484,226738,622069,292130,285949,94776,650202,390111,71897,53638,292666,534743,961136,204977,919975,233593,170804) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001204s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 475323 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000418s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 475323 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001636s ]