SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001169s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 520396 LIMIT 1 [ RunTime:0.000296s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 520396 [ RunTime:0.002089s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (156124,814342,1033271,665729,935478,639317,100435,44784,187255,1037782,1034102,704463,939049,348429,819438,387853,436943,569492,545375,73681,385150,367203,229184,247472,263846,757959,36995,84259,160195,654505,777653,362309,67829,353319,147545,42986,961801,857228,429700,808685,921981,456062,851121,96959,211506,636922,573003,977369,341509,518722,817170,405811,226528,443337,449219,586694,764139,1006750,859431,164655) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001077s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 520396 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000398s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 520396 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000441s ]