SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002618s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 415860 LIMIT 1 [ RunTime:0.002737s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 415860 [ RunTime:0.001675s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (486911,702778,500314,282155,103847,313705,724805,4142,241585,927618,390173,909954,505464,423812,666887,46707,109820,1047470,342928,274817,292263,140802,788816,563318,951982,16909,191750,535460,114182,35017,218412,463891,1021366,821667,716805,297102,679041,638093,26760,798349,860452,1043192,26266,884989,560905,581674,402339,235696,288842,521036,721933,750117,1047612,722120,75144,75891,526517,205424,329122,459014) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000970s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 415860 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000334s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 415860 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000451s ]