SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001130s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 38366 LIMIT 1 [ RunTime:0.000294s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 38366 [ RunTime:0.001578s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (837983,172239,927051,465942,442016,191706,919836,318853,28895,863205,1005289,259553,485858,765806,997815,422787,1011214,276149,896238,900837,202731,49692,71677,960839,505846,978097,35338,355749,413618,29827,180449,843954,275210,328886,949393,454641,265748,66675,26492,654491,162871,85017,387721,1032963,165277,883143,89143,176510,839404,901293,1021330,766699,211236,278024,263046,231643,215993,271637,708424,338809) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001714s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 38366 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000342s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 38366 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000485s ]