SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002395s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 341596 LIMIT 1 [ RunTime:0.000774s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 341596 [ RunTime:0.002700s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (132346,239695,418997,344183,418288,686981,1023509,966459,381182,320667,1012431,772280,821194,269082,40331,445911,1038754,242760,819188,281383,732768,884426,650908,859168,621180,177438,776976,158989,424466,642684,950232,459259,66589,187811,299862,1027298,22991,392309,22920,861282,335374,854415,807088,690582,980563,565541,606568,120173,973168,300815,792696,1045215,24950,200343,289123,905032,749050,1017350,548547,768294) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001389s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 341596 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000497s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 341596 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000591s ]