SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001213s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 547057 LIMIT 1 [ RunTime:0.000339s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 547057 [ RunTime:0.001829s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (641254,6647,25631,36825,1027365,248312,649626,136991,637411,606036,804777,495355,991197,952620,1029029,950058,734183,301177,596568,774477,420306,1014220,832069,686090,391919,135560,1025232,988494,559598,596768,555747,945972,416618,470086,92731,836124,507239,270891,897426,393005,682617,337600,647728,13190,726090,187535,821788,270465,974415,426168,5864,296681,180281,354254,311608,649752,137420,151323,61268,964558) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003406s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 547057 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000365s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 547057 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000571s ]