SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001325s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 414545 LIMIT 1 [ RunTime:0.000378s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 414545 [ RunTime:0.003401s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (12508,802900,346555,680402,1025046,926472,468837,191131,585649,361469,244629,930643,698578,89703,842493,178713,1026929,64736,841783,780293,584061,601693,900402,978857,873078,483951,791296,868310,1971,414807,662838,858131,273721,730371,831618,564788,789183,547647,480036,169290,338298,847060,35648,815706,1013046,220638,637814,388762,533532,656199,440535,785762,697323,352109,624802,382446,501602,185146,83786,831796) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002967s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 414545 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000537s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 414545 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000589s ]