SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001132s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 411063 LIMIT 1 [ RunTime:0.000371s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 411063 [ RunTime:0.001611s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (113869,834611,286029,1022727,398724,222551,647547,564786,772047,611128,102057,894318,975544,838409,771928,603396,358011,205648,78156,898360,997479,918610,279858,575509,344909,707459,1008169,913224,252117,598408,1004344,636807,333063,173482,32784,762664,1001968,567431,307061,158195,863347,819643,972625,374244,897043,38470,61007,872164,616132,1026053,957618,129858,254788,658650,135815,936154,203803,577214,138118,255547) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001662s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 411063 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000372s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 411063 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000416s ]