SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001160s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 316012 LIMIT 1 [ RunTime:0.000411s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 316012 [ RunTime:0.003343s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (800064,769125,34385,478547,61596,55572,477529,381114,835611,927262,544126,689392,719001,317865,860425,928491,154160,233291,186708,83011,546716,46914,184826,797788,247297,790300,170425,764817,772090,983323,579357,702031,387106,151751,289123,517754,548260,826360,1048217,805744,847358,272688,759270,867196,347945,869745,289903,137808,203780,533704,235588,609252,1019564,406543,799877,874632,529185,358125,572943,113641) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001008s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 316012 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000350s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 316012 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000481s ]