SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001989s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 654018 LIMIT 1 [ RunTime:0.001442s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 654018 [ RunTime:0.005602s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (410376,144248,572582,614150,643004,124204,10522,482208,748506,901208,799154,307133,700904,128155,588340,341926,490336,203725,798114,653761,577960,679929,875340,10178,210400,66437,538638,492576,706313,412940,414974,778621,406083,59062,1015059,841178,950392,899224,799271,138765,955061,409849,44311,161670,850054,426043,934521,749670,538579,525999,210131,1043945,877751,355437,112935,773087,358928,861205,601104,873736) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001162s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 654018 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001100s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 654018 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000857s ]